package com.ssish.saas.eccs.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class CorporateExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public CorporateExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andCorpCodeIsNull() {
            addCriterion("CORP_CODE is null");
            return (Criteria) this;
        }

        public Criteria andCorpCodeIsNotNull() {
            addCriterion("CORP_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCorpCodeEqualTo(String value) {
            addCriterion("CORP_CODE =", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotEqualTo(String value) {
            addCriterion("CORP_CODE <>", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeGreaterThan(String value) {
            addCriterion("CORP_CODE >", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CORP_CODE >=", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeLessThan(String value) {
            addCriterion("CORP_CODE <", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeLessThanOrEqualTo(String value) {
            addCriterion("CORP_CODE <=", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeLike(String value) {
            addCriterion("CORP_CODE like", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotLike(String value) {
            addCriterion("CORP_CODE not like", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeIn(List<String> values) {
            addCriterion("CORP_CODE in", values, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotIn(List<String> values) {
            addCriterion("CORP_CODE not in", values, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeBetween(String value1, String value2) {
            addCriterion("CORP_CODE between", value1, value2, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotBetween(String value1, String value2) {
            addCriterion("CORP_CODE not between", value1, value2, "corpCode");
            return (Criteria) this;
        }

        public Criteria andShortNameIsNull() {
            addCriterion("SHORT_NAME is null");
            return (Criteria) this;
        }

        public Criteria andShortNameIsNotNull() {
            addCriterion("SHORT_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andShortNameEqualTo(Object value) {
            addCriterion("SHORT_NAME =", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotEqualTo(Object value) {
            addCriterion("SHORT_NAME <>", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameGreaterThan(Object value) {
            addCriterion("SHORT_NAME >", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameGreaterThanOrEqualTo(Object value) {
            addCriterion("SHORT_NAME >=", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameLessThan(Object value) {
            addCriterion("SHORT_NAME <", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameLessThanOrEqualTo(Object value) {
            addCriterion("SHORT_NAME <=", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameIn(List<Object> values) {
            addCriterion("SHORT_NAME in", values, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotIn(List<Object> values) {
            addCriterion("SHORT_NAME not in", values, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameBetween(Object value1, Object value2) {
            addCriterion("SHORT_NAME between", value1, value2, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotBetween(Object value1, Object value2) {
            addCriterion("SHORT_NAME not between", value1, value2, "shortName");
            return (Criteria) this;
        }

        public Criteria andLongNameIsNull() {
            addCriterion("LONG_NAME is null");
            return (Criteria) this;
        }

        public Criteria andLongNameIsNotNull() {
            addCriterion("LONG_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andLongNameEqualTo(Object value) {
            addCriterion("LONG_NAME =", value, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameNotEqualTo(Object value) {
            addCriterion("LONG_NAME <>", value, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameGreaterThan(Object value) {
            addCriterion("LONG_NAME >", value, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameGreaterThanOrEqualTo(Object value) {
            addCriterion("LONG_NAME >=", value, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameLessThan(Object value) {
            addCriterion("LONG_NAME <", value, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameLessThanOrEqualTo(Object value) {
            addCriterion("LONG_NAME <=", value, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameIn(List<Object> values) {
            addCriterion("LONG_NAME in", values, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameNotIn(List<Object> values) {
            addCriterion("LONG_NAME not in", values, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameBetween(Object value1, Object value2) {
            addCriterion("LONG_NAME between", value1, value2, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameNotBetween(Object value1, Object value2) {
            addCriterion("LONG_NAME not between", value1, value2, "longName");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(Object value) {
            addCriterion("ADDRESS =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(Object value) {
            addCriterion("ADDRESS <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(Object value) {
            addCriterion("ADDRESS >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(Object value) {
            addCriterion("ADDRESS >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(Object value) {
            addCriterion("ADDRESS <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(Object value) {
            addCriterion("ADDRESS <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<Object> values) {
            addCriterion("ADDRESS in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<Object> values) {
            addCriterion("ADDRESS not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(Object value1, Object value2) {
            addCriterion("ADDRESS between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(Object value1, Object value2) {
            addCriterion("ADDRESS not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNull() {
            addCriterion("POSTCODE is null");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNotNull() {
            addCriterion("POSTCODE is not null");
            return (Criteria) this;
        }

        public Criteria andPostcodeEqualTo(String value) {
            addCriterion("POSTCODE =", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotEqualTo(String value) {
            addCriterion("POSTCODE <>", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThan(String value) {
            addCriterion("POSTCODE >", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThanOrEqualTo(String value) {
            addCriterion("POSTCODE >=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThan(String value) {
            addCriterion("POSTCODE <", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThanOrEqualTo(String value) {
            addCriterion("POSTCODE <=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLike(String value) {
            addCriterion("POSTCODE like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotLike(String value) {
            addCriterion("POSTCODE not like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeIn(List<String> values) {
            addCriterion("POSTCODE in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotIn(List<String> values) {
            addCriterion("POSTCODE not in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeBetween(String value1, String value2) {
            addCriterion("POSTCODE between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotBetween(String value1, String value2) {
            addCriterion("POSTCODE not between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("CITY is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("CITY is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("CITY =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("CITY <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("CITY >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("CITY >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("CITY <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("CITY <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("CITY like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("CITY not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("CITY in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("CITY not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("CITY between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("CITY not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andStateIsNull() {
            addCriterion("STATE is null");
            return (Criteria) this;
        }

        public Criteria andStateIsNotNull() {
            addCriterion("STATE is not null");
            return (Criteria) this;
        }

        public Criteria andStateEqualTo(String value) {
            addCriterion("STATE =", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotEqualTo(String value) {
            addCriterion("STATE <>", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThan(String value) {
            addCriterion("STATE >", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE >=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThan(String value) {
            addCriterion("STATE <", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThanOrEqualTo(String value) {
            addCriterion("STATE <=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLike(String value) {
            addCriterion("STATE like", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotLike(String value) {
            addCriterion("STATE not like", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateIn(List<String> values) {
            addCriterion("STATE in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotIn(List<String> values) {
            addCriterion("STATE not in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateBetween(String value1, String value2) {
            addCriterion("STATE between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotBetween(String value1, String value2) {
            addCriterion("STATE not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andCountryIsNull() {
            addCriterion("COUNTRY is null");
            return (Criteria) this;
        }

        public Criteria andCountryIsNotNull() {
            addCriterion("COUNTRY is not null");
            return (Criteria) this;
        }

        public Criteria andCountryEqualTo(String value) {
            addCriterion("COUNTRY =", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotEqualTo(String value) {
            addCriterion("COUNTRY <>", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryGreaterThan(String value) {
            addCriterion("COUNTRY >", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryGreaterThanOrEqualTo(String value) {
            addCriterion("COUNTRY >=", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLessThan(String value) {
            addCriterion("COUNTRY <", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLessThanOrEqualTo(String value) {
            addCriterion("COUNTRY <=", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLike(String value) {
            addCriterion("COUNTRY like", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotLike(String value) {
            addCriterion("COUNTRY not like", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryIn(List<String> values) {
            addCriterion("COUNTRY in", values, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotIn(List<String> values) {
            addCriterion("COUNTRY not in", values, "country");
            return (Criteria) this;
        }

        public Criteria andCountryBetween(String value1, String value2) {
            addCriterion("COUNTRY between", value1, value2, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotBetween(String value1, String value2) {
            addCriterion("COUNTRY not between", value1, value2, "country");
            return (Criteria) this;
        }

        public Criteria andTelNoIsNull() {
            addCriterion("TEL_NO is null");
            return (Criteria) this;
        }

        public Criteria andTelNoIsNotNull() {
            addCriterion("TEL_NO is not null");
            return (Criteria) this;
        }

        public Criteria andTelNoEqualTo(String value) {
            addCriterion("TEL_NO =", value, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoNotEqualTo(String value) {
            addCriterion("TEL_NO <>", value, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoGreaterThan(String value) {
            addCriterion("TEL_NO >", value, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoGreaterThanOrEqualTo(String value) {
            addCriterion("TEL_NO >=", value, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoLessThan(String value) {
            addCriterion("TEL_NO <", value, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoLessThanOrEqualTo(String value) {
            addCriterion("TEL_NO <=", value, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoLike(String value) {
            addCriterion("TEL_NO like", value, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoNotLike(String value) {
            addCriterion("TEL_NO not like", value, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoIn(List<String> values) {
            addCriterion("TEL_NO in", values, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoNotIn(List<String> values) {
            addCriterion("TEL_NO not in", values, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoBetween(String value1, String value2) {
            addCriterion("TEL_NO between", value1, value2, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoNotBetween(String value1, String value2) {
            addCriterion("TEL_NO not between", value1, value2, "telNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoIsNull() {
            addCriterion("FAX_NO is null");
            return (Criteria) this;
        }

        public Criteria andFaxNoIsNotNull() {
            addCriterion("FAX_NO is not null");
            return (Criteria) this;
        }

        public Criteria andFaxNoEqualTo(String value) {
            addCriterion("FAX_NO =", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoNotEqualTo(String value) {
            addCriterion("FAX_NO <>", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoGreaterThan(String value) {
            addCriterion("FAX_NO >", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoGreaterThanOrEqualTo(String value) {
            addCriterion("FAX_NO >=", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoLessThan(String value) {
            addCriterion("FAX_NO <", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoLessThanOrEqualTo(String value) {
            addCriterion("FAX_NO <=", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoLike(String value) {
            addCriterion("FAX_NO like", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoNotLike(String value) {
            addCriterion("FAX_NO not like", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoIn(List<String> values) {
            addCriterion("FAX_NO in", values, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoNotIn(List<String> values) {
            addCriterion("FAX_NO not in", values, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoBetween(String value1, String value2) {
            addCriterion("FAX_NO between", value1, value2, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoNotBetween(String value1, String value2) {
            addCriterion("FAX_NO not between", value1, value2, "faxNo");
            return (Criteria) this;
        }

        public Criteria andContactPersonIsNull() {
            addCriterion("CONTACT_PERSON is null");
            return (Criteria) this;
        }

        public Criteria andContactPersonIsNotNull() {
            addCriterion("CONTACT_PERSON is not null");
            return (Criteria) this;
        }

        public Criteria andContactPersonEqualTo(String value) {
            addCriterion("CONTACT_PERSON =", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotEqualTo(String value) {
            addCriterion("CONTACT_PERSON <>", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonGreaterThan(String value) {
            addCriterion("CONTACT_PERSON >", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonGreaterThanOrEqualTo(String value) {
            addCriterion("CONTACT_PERSON >=", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonLessThan(String value) {
            addCriterion("CONTACT_PERSON <", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonLessThanOrEqualTo(String value) {
            addCriterion("CONTACT_PERSON <=", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonLike(String value) {
            addCriterion("CONTACT_PERSON like", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotLike(String value) {
            addCriterion("CONTACT_PERSON not like", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonIn(List<String> values) {
            addCriterion("CONTACT_PERSON in", values, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotIn(List<String> values) {
            addCriterion("CONTACT_PERSON not in", values, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonBetween(String value1, String value2) {
            addCriterion("CONTACT_PERSON between", value1, value2, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotBetween(String value1, String value2) {
            addCriterion("CONTACT_PERSON not between", value1, value2, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andCorpTypeIsNull() {
            addCriterion("CORP_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andCorpTypeIsNotNull() {
            addCriterion("CORP_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andCorpTypeEqualTo(String value) {
            addCriterion("CORP_TYPE =", value, "corpType");
            return (Criteria) this;
        }

        public Criteria andCorpTypeNotEqualTo(String value) {
            addCriterion("CORP_TYPE <>", value, "corpType");
            return (Criteria) this;
        }

        public Criteria andCorpTypeGreaterThan(String value) {
            addCriterion("CORP_TYPE >", value, "corpType");
            return (Criteria) this;
        }

        public Criteria andCorpTypeGreaterThanOrEqualTo(String value) {
            addCriterion("CORP_TYPE >=", value, "corpType");
            return (Criteria) this;
        }

        public Criteria andCorpTypeLessThan(String value) {
            addCriterion("CORP_TYPE <", value, "corpType");
            return (Criteria) this;
        }

        public Criteria andCorpTypeLessThanOrEqualTo(String value) {
            addCriterion("CORP_TYPE <=", value, "corpType");
            return (Criteria) this;
        }

        public Criteria andCorpTypeLike(String value) {
            addCriterion("CORP_TYPE like", value, "corpType");
            return (Criteria) this;
        }

        public Criteria andCorpTypeNotLike(String value) {
            addCriterion("CORP_TYPE not like", value, "corpType");
            return (Criteria) this;
        }

        public Criteria andCorpTypeIn(List<String> values) {
            addCriterion("CORP_TYPE in", values, "corpType");
            return (Criteria) this;
        }

        public Criteria andCorpTypeNotIn(List<String> values) {
            addCriterion("CORP_TYPE not in", values, "corpType");
            return (Criteria) this;
        }

        public Criteria andCorpTypeBetween(String value1, String value2) {
            addCriterion("CORP_TYPE between", value1, value2, "corpType");
            return (Criteria) this;
        }

        public Criteria andCorpTypeNotBetween(String value1, String value2) {
            addCriterion("CORP_TYPE not between", value1, value2, "corpType");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("EMAIL is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("EMAIL is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("EMAIL =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("EMAIL <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("EMAIL >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("EMAIL >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("EMAIL <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("EMAIL <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("EMAIL like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("EMAIL not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("EMAIL in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("EMAIL not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("EMAIL between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("EMAIL not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andPayorCodeIsNull() {
            addCriterion("PAYOR_CODE is null");
            return (Criteria) this;
        }

        public Criteria andPayorCodeIsNotNull() {
            addCriterion("PAYOR_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andPayorCodeEqualTo(String value) {
            addCriterion("PAYOR_CODE =", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeNotEqualTo(String value) {
            addCriterion("PAYOR_CODE <>", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeGreaterThan(String value) {
            addCriterion("PAYOR_CODE >", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeGreaterThanOrEqualTo(String value) {
            addCriterion("PAYOR_CODE >=", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeLessThan(String value) {
            addCriterion("PAYOR_CODE <", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeLessThanOrEqualTo(String value) {
            addCriterion("PAYOR_CODE <=", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeLike(String value) {
            addCriterion("PAYOR_CODE like", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeNotLike(String value) {
            addCriterion("PAYOR_CODE not like", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeIn(List<String> values) {
            addCriterion("PAYOR_CODE in", values, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeNotIn(List<String> values) {
            addCriterion("PAYOR_CODE not in", values, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeBetween(String value1, String value2) {
            addCriterion("PAYOR_CODE between", value1, value2, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeNotBetween(String value1, String value2) {
            addCriterion("PAYOR_CODE not between", value1, value2, "payorCode");
            return (Criteria) this;
        }

        public Criteria andEdiAddressIsNull() {
            addCriterion("EDI_ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andEdiAddressIsNotNull() {
            addCriterion("EDI_ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andEdiAddressEqualTo(String value) {
            addCriterion("EDI_ADDRESS =", value, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressNotEqualTo(String value) {
            addCriterion("EDI_ADDRESS <>", value, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressGreaterThan(String value) {
            addCriterion("EDI_ADDRESS >", value, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressGreaterThanOrEqualTo(String value) {
            addCriterion("EDI_ADDRESS >=", value, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressLessThan(String value) {
            addCriterion("EDI_ADDRESS <", value, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressLessThanOrEqualTo(String value) {
            addCriterion("EDI_ADDRESS <=", value, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressLike(String value) {
            addCriterion("EDI_ADDRESS like", value, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressNotLike(String value) {
            addCriterion("EDI_ADDRESS not like", value, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressIn(List<String> values) {
            addCriterion("EDI_ADDRESS in", values, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressNotIn(List<String> values) {
            addCriterion("EDI_ADDRESS not in", values, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressBetween(String value1, String value2) {
            addCriterion("EDI_ADDRESS between", value1, value2, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressNotBetween(String value1, String value2) {
            addCriterion("EDI_ADDRESS not between", value1, value2, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsIsNull() {
            addCriterion("EDI_CLAIMS is null");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsIsNotNull() {
            addCriterion("EDI_CLAIMS is not null");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsEqualTo(String value) {
            addCriterion("EDI_CLAIMS =", value, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsNotEqualTo(String value) {
            addCriterion("EDI_CLAIMS <>", value, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsGreaterThan(String value) {
            addCriterion("EDI_CLAIMS >", value, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsGreaterThanOrEqualTo(String value) {
            addCriterion("EDI_CLAIMS >=", value, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsLessThan(String value) {
            addCriterion("EDI_CLAIMS <", value, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsLessThanOrEqualTo(String value) {
            addCriterion("EDI_CLAIMS <=", value, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsLike(String value) {
            addCriterion("EDI_CLAIMS like", value, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsNotLike(String value) {
            addCriterion("EDI_CLAIMS not like", value, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsIn(List<String> values) {
            addCriterion("EDI_CLAIMS in", values, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsNotIn(List<String> values) {
            addCriterion("EDI_CLAIMS not in", values, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsBetween(String value1, String value2) {
            addCriterion("EDI_CLAIMS between", value1, value2, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsNotBetween(String value1, String value2) {
            addCriterion("EDI_CLAIMS not between", value1, value2, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andPrintChitIsNull() {
            addCriterion("PRINT_CHIT is null");
            return (Criteria) this;
        }

        public Criteria andPrintChitIsNotNull() {
            addCriterion("PRINT_CHIT is not null");
            return (Criteria) this;
        }

        public Criteria andPrintChitEqualTo(String value) {
            addCriterion("PRINT_CHIT =", value, "printChit");
            return (Criteria) this;
        }

        public Criteria andPrintChitNotEqualTo(String value) {
            addCriterion("PRINT_CHIT <>", value, "printChit");
            return (Criteria) this;
        }

        public Criteria andPrintChitGreaterThan(String value) {
            addCriterion("PRINT_CHIT >", value, "printChit");
            return (Criteria) this;
        }

        public Criteria andPrintChitGreaterThanOrEqualTo(String value) {
            addCriterion("PRINT_CHIT >=", value, "printChit");
            return (Criteria) this;
        }

        public Criteria andPrintChitLessThan(String value) {
            addCriterion("PRINT_CHIT <", value, "printChit");
            return (Criteria) this;
        }

        public Criteria andPrintChitLessThanOrEqualTo(String value) {
            addCriterion("PRINT_CHIT <=", value, "printChit");
            return (Criteria) this;
        }

        public Criteria andPrintChitLike(String value) {
            addCriterion("PRINT_CHIT like", value, "printChit");
            return (Criteria) this;
        }

        public Criteria andPrintChitNotLike(String value) {
            addCriterion("PRINT_CHIT not like", value, "printChit");
            return (Criteria) this;
        }

        public Criteria andPrintChitIn(List<String> values) {
            addCriterion("PRINT_CHIT in", values, "printChit");
            return (Criteria) this;
        }

        public Criteria andPrintChitNotIn(List<String> values) {
            addCriterion("PRINT_CHIT not in", values, "printChit");
            return (Criteria) this;
        }

        public Criteria andPrintChitBetween(String value1, String value2) {
            addCriterion("PRINT_CHIT between", value1, value2, "printChit");
            return (Criteria) this;
        }

        public Criteria andPrintChitNotBetween(String value1, String value2) {
            addCriterion("PRINT_CHIT not between", value1, value2, "printChit");
            return (Criteria) this;
        }

        public Criteria andCommCodeIsNull() {
            addCriterion("COMM_CODE is null");
            return (Criteria) this;
        }

        public Criteria andCommCodeIsNotNull() {
            addCriterion("COMM_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCommCodeEqualTo(String value) {
            addCriterion("COMM_CODE =", value, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeNotEqualTo(String value) {
            addCriterion("COMM_CODE <>", value, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeGreaterThan(String value) {
            addCriterion("COMM_CODE >", value, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeGreaterThanOrEqualTo(String value) {
            addCriterion("COMM_CODE >=", value, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeLessThan(String value) {
            addCriterion("COMM_CODE <", value, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeLessThanOrEqualTo(String value) {
            addCriterion("COMM_CODE <=", value, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeLike(String value) {
            addCriterion("COMM_CODE like", value, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeNotLike(String value) {
            addCriterion("COMM_CODE not like", value, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeIn(List<String> values) {
            addCriterion("COMM_CODE in", values, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeNotIn(List<String> values) {
            addCriterion("COMM_CODE not in", values, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeBetween(String value1, String value2) {
            addCriterion("COMM_CODE between", value1, value2, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeNotBetween(String value1, String value2) {
            addCriterion("COMM_CODE not between", value1, value2, "commCode");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatIsNull() {
            addCriterion("INVOICE_FORMAT is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatIsNotNull() {
            addCriterion("INVOICE_FORMAT is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatEqualTo(Short value) {
            addCriterion("INVOICE_FORMAT =", value, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatNotEqualTo(Short value) {
            addCriterion("INVOICE_FORMAT <>", value, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatGreaterThan(Short value) {
            addCriterion("INVOICE_FORMAT >", value, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatGreaterThanOrEqualTo(Short value) {
            addCriterion("INVOICE_FORMAT >=", value, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatLessThan(Short value) {
            addCriterion("INVOICE_FORMAT <", value, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatLessThanOrEqualTo(Short value) {
            addCriterion("INVOICE_FORMAT <=", value, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatIn(List<Short> values) {
            addCriterion("INVOICE_FORMAT in", values, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatNotIn(List<Short> values) {
            addCriterion("INVOICE_FORMAT not in", values, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatBetween(Short value1, Short value2) {
            addCriterion("INVOICE_FORMAT between", value1, value2, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatNotBetween(Short value1, Short value2) {
            addCriterion("INVOICE_FORMAT not between", value1, value2, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceCycleIsNull() {
            addCriterion("INVOICE_CYCLE is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceCycleIsNotNull() {
            addCriterion("INVOICE_CYCLE is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceCycleEqualTo(Short value) {
            addCriterion("INVOICE_CYCLE =", value, "invoiceCycle");
            return (Criteria) this;
        }

        public Criteria andInvoiceCycleNotEqualTo(Short value) {
            addCriterion("INVOICE_CYCLE <>", value, "invoiceCycle");
            return (Criteria) this;
        }

        public Criteria andInvoiceCycleGreaterThan(Short value) {
            addCriterion("INVOICE_CYCLE >", value, "invoiceCycle");
            return (Criteria) this;
        }

        public Criteria andInvoiceCycleGreaterThanOrEqualTo(Short value) {
            addCriterion("INVOICE_CYCLE >=", value, "invoiceCycle");
            return (Criteria) this;
        }

        public Criteria andInvoiceCycleLessThan(Short value) {
            addCriterion("INVOICE_CYCLE <", value, "invoiceCycle");
            return (Criteria) this;
        }

        public Criteria andInvoiceCycleLessThanOrEqualTo(Short value) {
            addCriterion("INVOICE_CYCLE <=", value, "invoiceCycle");
            return (Criteria) this;
        }

        public Criteria andInvoiceCycleIn(List<Short> values) {
            addCriterion("INVOICE_CYCLE in", values, "invoiceCycle");
            return (Criteria) this;
        }

        public Criteria andInvoiceCycleNotIn(List<Short> values) {
            addCriterion("INVOICE_CYCLE not in", values, "invoiceCycle");
            return (Criteria) this;
        }

        public Criteria andInvoiceCycleBetween(Short value1, Short value2) {
            addCriterion("INVOICE_CYCLE between", value1, value2, "invoiceCycle");
            return (Criteria) this;
        }

        public Criteria andInvoiceCycleNotBetween(Short value1, Short value2) {
            addCriterion("INVOICE_CYCLE not between", value1, value2, "invoiceCycle");
            return (Criteria) this;
        }

        public Criteria andCutoffDateIsNull() {
            addCriterion("CUTOFF_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCutoffDateIsNotNull() {
            addCriterion("CUTOFF_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCutoffDateEqualTo(Date value) {
            addCriterion("CUTOFF_DATE =", value, "cutoffDate");
            return (Criteria) this;
        }

        public Criteria andCutoffDateNotEqualTo(Date value) {
            addCriterion("CUTOFF_DATE <>", value, "cutoffDate");
            return (Criteria) this;
        }

        public Criteria andCutoffDateGreaterThan(Date value) {
            addCriterion("CUTOFF_DATE >", value, "cutoffDate");
            return (Criteria) this;
        }

        public Criteria andCutoffDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CUTOFF_DATE >=", value, "cutoffDate");
            return (Criteria) this;
        }

        public Criteria andCutoffDateLessThan(Date value) {
            addCriterion("CUTOFF_DATE <", value, "cutoffDate");
            return (Criteria) this;
        }

        public Criteria andCutoffDateLessThanOrEqualTo(Date value) {
            addCriterion("CUTOFF_DATE <=", value, "cutoffDate");
            return (Criteria) this;
        }

        public Criteria andCutoffDateIn(List<Date> values) {
            addCriterion("CUTOFF_DATE in", values, "cutoffDate");
            return (Criteria) this;
        }

        public Criteria andCutoffDateNotIn(List<Date> values) {
            addCriterion("CUTOFF_DATE not in", values, "cutoffDate");
            return (Criteria) this;
        }

        public Criteria andCutoffDateBetween(Date value1, Date value2) {
            addCriterion("CUTOFF_DATE between", value1, value2, "cutoffDate");
            return (Criteria) this;
        }

        public Criteria andCutoffDateNotBetween(Date value1, Date value2) {
            addCriterion("CUTOFF_DATE not between", value1, value2, "cutoffDate");
            return (Criteria) this;
        }

        public Criteria andActiveFlagIsNull() {
            addCriterion("ACTIVE_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andActiveFlagIsNotNull() {
            addCriterion("ACTIVE_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andActiveFlagEqualTo(String value) {
            addCriterion("ACTIVE_FLAG =", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotEqualTo(String value) {
            addCriterion("ACTIVE_FLAG <>", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagGreaterThan(String value) {
            addCriterion("ACTIVE_FLAG >", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagGreaterThanOrEqualTo(String value) {
            addCriterion("ACTIVE_FLAG >=", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagLessThan(String value) {
            addCriterion("ACTIVE_FLAG <", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagLessThanOrEqualTo(String value) {
            addCriterion("ACTIVE_FLAG <=", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagLike(String value) {
            addCriterion("ACTIVE_FLAG like", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotLike(String value) {
            addCriterion("ACTIVE_FLAG not like", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagIn(List<String> values) {
            addCriterion("ACTIVE_FLAG in", values, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotIn(List<String> values) {
            addCriterion("ACTIVE_FLAG not in", values, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagBetween(String value1, String value2) {
            addCriterion("ACTIVE_FLAG between", value1, value2, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotBetween(String value1, String value2) {
            addCriterion("ACTIVE_FLAG not between", value1, value2, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andLasteditDateIsNull() {
            addCriterion("LASTEDIT_DATE is null");
            return (Criteria) this;
        }

        public Criteria andLasteditDateIsNotNull() {
            addCriterion("LASTEDIT_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andLasteditDateEqualTo(Date value) {
            addCriterion("LASTEDIT_DATE =", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateNotEqualTo(Date value) {
            addCriterion("LASTEDIT_DATE <>", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateGreaterThan(Date value) {
            addCriterion("LASTEDIT_DATE >", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateGreaterThanOrEqualTo(Date value) {
            addCriterion("LASTEDIT_DATE >=", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateLessThan(Date value) {
            addCriterion("LASTEDIT_DATE <", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateLessThanOrEqualTo(Date value) {
            addCriterion("LASTEDIT_DATE <=", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateIn(List<Date> values) {
            addCriterion("LASTEDIT_DATE in", values, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateNotIn(List<Date> values) {
            addCriterion("LASTEDIT_DATE not in", values, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateBetween(Date value1, Date value2) {
            addCriterion("LASTEDIT_DATE between", value1, value2, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateNotBetween(Date value1, Date value2) {
            addCriterion("LASTEDIT_DATE not between", value1, value2, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andUserCodeIsNull() {
            addCriterion("USER_CODE is null");
            return (Criteria) this;
        }

        public Criteria andUserCodeIsNotNull() {
            addCriterion("USER_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andUserCodeEqualTo(String value) {
            addCriterion("USER_CODE =", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotEqualTo(String value) {
            addCriterion("USER_CODE <>", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeGreaterThan(String value) {
            addCriterion("USER_CODE >", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeGreaterThanOrEqualTo(String value) {
            addCriterion("USER_CODE >=", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeLessThan(String value) {
            addCriterion("USER_CODE <", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeLessThanOrEqualTo(String value) {
            addCriterion("USER_CODE <=", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeLike(String value) {
            addCriterion("USER_CODE like", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotLike(String value) {
            addCriterion("USER_CODE not like", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeIn(List<String> values) {
            addCriterion("USER_CODE in", values, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotIn(List<String> values) {
            addCriterion("USER_CODE not in", values, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeBetween(String value1, String value2) {
            addCriterion("USER_CODE between", value1, value2, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotBetween(String value1, String value2) {
            addCriterion("USER_CODE not between", value1, value2, "userCode");
            return (Criteria) this;
        }

        public Criteria andCorpInvstIsNull() {
            addCriterion("CORP_INVST is null");
            return (Criteria) this;
        }

        public Criteria andCorpInvstIsNotNull() {
            addCriterion("CORP_INVST is not null");
            return (Criteria) this;
        }

        public Criteria andCorpInvstEqualTo(BigDecimal value) {
            addCriterion("CORP_INVST =", value, "corpInvst");
            return (Criteria) this;
        }

        public Criteria andCorpInvstNotEqualTo(BigDecimal value) {
            addCriterion("CORP_INVST <>", value, "corpInvst");
            return (Criteria) this;
        }

        public Criteria andCorpInvstGreaterThan(BigDecimal value) {
            addCriterion("CORP_INVST >", value, "corpInvst");
            return (Criteria) this;
        }

        public Criteria andCorpInvstGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CORP_INVST >=", value, "corpInvst");
            return (Criteria) this;
        }

        public Criteria andCorpInvstLessThan(BigDecimal value) {
            addCriterion("CORP_INVST <", value, "corpInvst");
            return (Criteria) this;
        }

        public Criteria andCorpInvstLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CORP_INVST <=", value, "corpInvst");
            return (Criteria) this;
        }

        public Criteria andCorpInvstIn(List<BigDecimal> values) {
            addCriterion("CORP_INVST in", values, "corpInvst");
            return (Criteria) this;
        }

        public Criteria andCorpInvstNotIn(List<BigDecimal> values) {
            addCriterion("CORP_INVST not in", values, "corpInvst");
            return (Criteria) this;
        }

        public Criteria andCorpInvstBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CORP_INVST between", value1, value2, "corpInvst");
            return (Criteria) this;
        }

        public Criteria andCorpInvstNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CORP_INVST not between", value1, value2, "corpInvst");
            return (Criteria) this;
        }

        public Criteria andCorpUtilzPIsNull() {
            addCriterion("CORP_UTILZ_P is null");
            return (Criteria) this;
        }

        public Criteria andCorpUtilzPIsNotNull() {
            addCriterion("CORP_UTILZ_P is not null");
            return (Criteria) this;
        }

        public Criteria andCorpUtilzPEqualTo(Integer value) {
            addCriterion("CORP_UTILZ_P =", value, "corpUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpUtilzPNotEqualTo(Integer value) {
            addCriterion("CORP_UTILZ_P <>", value, "corpUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpUtilzPGreaterThan(Integer value) {
            addCriterion("CORP_UTILZ_P >", value, "corpUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpUtilzPGreaterThanOrEqualTo(Integer value) {
            addCriterion("CORP_UTILZ_P >=", value, "corpUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpUtilzPLessThan(Integer value) {
            addCriterion("CORP_UTILZ_P <", value, "corpUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpUtilzPLessThanOrEqualTo(Integer value) {
            addCriterion("CORP_UTILZ_P <=", value, "corpUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpUtilzPIn(List<Integer> values) {
            addCriterion("CORP_UTILZ_P in", values, "corpUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpUtilzPNotIn(List<Integer> values) {
            addCriterion("CORP_UTILZ_P not in", values, "corpUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpUtilzPBetween(Integer value1, Integer value2) {
            addCriterion("CORP_UTILZ_P between", value1, value2, "corpUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpUtilzPNotBetween(Integer value1, Integer value2) {
            addCriterion("CORP_UTILZ_P not between", value1, value2, "corpUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpDisUtilzPIsNull() {
            addCriterion("CORP_DIS_UTILZ_P is null");
            return (Criteria) this;
        }

        public Criteria andCorpDisUtilzPIsNotNull() {
            addCriterion("CORP_DIS_UTILZ_P is not null");
            return (Criteria) this;
        }

        public Criteria andCorpDisUtilzPEqualTo(Integer value) {
            addCriterion("CORP_DIS_UTILZ_P =", value, "corpDisUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpDisUtilzPNotEqualTo(Integer value) {
            addCriterion("CORP_DIS_UTILZ_P <>", value, "corpDisUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpDisUtilzPGreaterThan(Integer value) {
            addCriterion("CORP_DIS_UTILZ_P >", value, "corpDisUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpDisUtilzPGreaterThanOrEqualTo(Integer value) {
            addCriterion("CORP_DIS_UTILZ_P >=", value, "corpDisUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpDisUtilzPLessThan(Integer value) {
            addCriterion("CORP_DIS_UTILZ_P <", value, "corpDisUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpDisUtilzPLessThanOrEqualTo(Integer value) {
            addCriterion("CORP_DIS_UTILZ_P <=", value, "corpDisUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpDisUtilzPIn(List<Integer> values) {
            addCriterion("CORP_DIS_UTILZ_P in", values, "corpDisUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpDisUtilzPNotIn(List<Integer> values) {
            addCriterion("CORP_DIS_UTILZ_P not in", values, "corpDisUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpDisUtilzPBetween(Integer value1, Integer value2) {
            addCriterion("CORP_DIS_UTILZ_P between", value1, value2, "corpDisUtilzP");
            return (Criteria) this;
        }

        public Criteria andCorpDisUtilzPNotBetween(Integer value1, Integer value2) {
            addCriterion("CORP_DIS_UTILZ_P not between", value1, value2, "corpDisUtilzP");
            return (Criteria) this;
        }

        public Criteria andDbcdIsNull() {
            addCriterion("DBCD is null");
            return (Criteria) this;
        }

        public Criteria andDbcdIsNotNull() {
            addCriterion("DBCD is not null");
            return (Criteria) this;
        }

        public Criteria andDbcdEqualTo(String value) {
            addCriterion("DBCD =", value, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdNotEqualTo(String value) {
            addCriterion("DBCD <>", value, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdGreaterThan(String value) {
            addCriterion("DBCD >", value, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdGreaterThanOrEqualTo(String value) {
            addCriterion("DBCD >=", value, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdLessThan(String value) {
            addCriterion("DBCD <", value, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdLessThanOrEqualTo(String value) {
            addCriterion("DBCD <=", value, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdLike(String value) {
            addCriterion("DBCD like", value, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdNotLike(String value) {
            addCriterion("DBCD not like", value, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdIn(List<String> values) {
            addCriterion("DBCD in", values, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdNotIn(List<String> values) {
            addCriterion("DBCD not in", values, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdBetween(String value1, String value2) {
            addCriterion("DBCD between", value1, value2, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdNotBetween(String value1, String value2) {
            addCriterion("DBCD not between", value1, value2, "dbcd");
            return (Criteria) this;
        }

        public Criteria andRenewalModeIsNull() {
            addCriterion("RENEWAL_MODE is null");
            return (Criteria) this;
        }

        public Criteria andRenewalModeIsNotNull() {
            addCriterion("RENEWAL_MODE is not null");
            return (Criteria) this;
        }

        public Criteria andRenewalModeEqualTo(String value) {
            addCriterion("RENEWAL_MODE =", value, "renewalMode");
            return (Criteria) this;
        }

        public Criteria andRenewalModeNotEqualTo(String value) {
            addCriterion("RENEWAL_MODE <>", value, "renewalMode");
            return (Criteria) this;
        }

        public Criteria andRenewalModeGreaterThan(String value) {
            addCriterion("RENEWAL_MODE >", value, "renewalMode");
            return (Criteria) this;
        }

        public Criteria andRenewalModeGreaterThanOrEqualTo(String value) {
            addCriterion("RENEWAL_MODE >=", value, "renewalMode");
            return (Criteria) this;
        }

        public Criteria andRenewalModeLessThan(String value) {
            addCriterion("RENEWAL_MODE <", value, "renewalMode");
            return (Criteria) this;
        }

        public Criteria andRenewalModeLessThanOrEqualTo(String value) {
            addCriterion("RENEWAL_MODE <=", value, "renewalMode");
            return (Criteria) this;
        }

        public Criteria andRenewalModeLike(String value) {
            addCriterion("RENEWAL_MODE like", value, "renewalMode");
            return (Criteria) this;
        }

        public Criteria andRenewalModeNotLike(String value) {
            addCriterion("RENEWAL_MODE not like", value, "renewalMode");
            return (Criteria) this;
        }

        public Criteria andRenewalModeIn(List<String> values) {
            addCriterion("RENEWAL_MODE in", values, "renewalMode");
            return (Criteria) this;
        }

        public Criteria andRenewalModeNotIn(List<String> values) {
            addCriterion("RENEWAL_MODE not in", values, "renewalMode");
            return (Criteria) this;
        }

        public Criteria andRenewalModeBetween(String value1, String value2) {
            addCriterion("RENEWAL_MODE between", value1, value2, "renewalMode");
            return (Criteria) this;
        }

        public Criteria andRenewalModeNotBetween(String value1, String value2) {
            addCriterion("RENEWAL_MODE not between", value1, value2, "renewalMode");
            return (Criteria) this;
        }

        public Criteria andActivationDateIsNull() {
            addCriterion("ACTIVATION_DATE is null");
            return (Criteria) this;
        }

        public Criteria andActivationDateIsNotNull() {
            addCriterion("ACTIVATION_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andActivationDateEqualTo(Date value) {
            addCriterion("ACTIVATION_DATE =", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateNotEqualTo(Date value) {
            addCriterion("ACTIVATION_DATE <>", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateGreaterThan(Date value) {
            addCriterion("ACTIVATION_DATE >", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateGreaterThanOrEqualTo(Date value) {
            addCriterion("ACTIVATION_DATE >=", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateLessThan(Date value) {
            addCriterion("ACTIVATION_DATE <", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateLessThanOrEqualTo(Date value) {
            addCriterion("ACTIVATION_DATE <=", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateIn(List<Date> values) {
            addCriterion("ACTIVATION_DATE in", values, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateNotIn(List<Date> values) {
            addCriterion("ACTIVATION_DATE not in", values, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateBetween(Date value1, Date value2) {
            addCriterion("ACTIVATION_DATE between", value1, value2, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateNotBetween(Date value1, Date value2) {
            addCriterion("ACTIVATION_DATE not between", value1, value2, "activationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateIsNull() {
            addCriterion("CANCELLATION_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCancellationDateIsNotNull() {
            addCriterion("CANCELLATION_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCancellationDateEqualTo(Date value) {
            addCriterion("CANCELLATION_DATE =", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateNotEqualTo(Date value) {
            addCriterion("CANCELLATION_DATE <>", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateGreaterThan(Date value) {
            addCriterion("CANCELLATION_DATE >", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CANCELLATION_DATE >=", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateLessThan(Date value) {
            addCriterion("CANCELLATION_DATE <", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateLessThanOrEqualTo(Date value) {
            addCriterion("CANCELLATION_DATE <=", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateIn(List<Date> values) {
            addCriterion("CANCELLATION_DATE in", values, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateNotIn(List<Date> values) {
            addCriterion("CANCELLATION_DATE not in", values, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateBetween(Date value1, Date value2) {
            addCriterion("CANCELLATION_DATE between", value1, value2, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateNotBetween(Date value1, Date value2) {
            addCriterion("CANCELLATION_DATE not between", value1, value2, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andServiceFeeIsNull() {
            addCriterion("SERVICE_FEE is null");
            return (Criteria) this;
        }

        public Criteria andServiceFeeIsNotNull() {
            addCriterion("SERVICE_FEE is not null");
            return (Criteria) this;
        }

        public Criteria andServiceFeeEqualTo(BigDecimal value) {
            addCriterion("SERVICE_FEE =", value, "serviceFee");
            return (Criteria) this;
        }

        public Criteria andServiceFeeNotEqualTo(BigDecimal value) {
            addCriterion("SERVICE_FEE <>", value, "serviceFee");
            return (Criteria) this;
        }

        public Criteria andServiceFeeGreaterThan(BigDecimal value) {
            addCriterion("SERVICE_FEE >", value, "serviceFee");
            return (Criteria) this;
        }

        public Criteria andServiceFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SERVICE_FEE >=", value, "serviceFee");
            return (Criteria) this;
        }

        public Criteria andServiceFeeLessThan(BigDecimal value) {
            addCriterion("SERVICE_FEE <", value, "serviceFee");
            return (Criteria) this;
        }

        public Criteria andServiceFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SERVICE_FEE <=", value, "serviceFee");
            return (Criteria) this;
        }

        public Criteria andServiceFeeIn(List<BigDecimal> values) {
            addCriterion("SERVICE_FEE in", values, "serviceFee");
            return (Criteria) this;
        }

        public Criteria andServiceFeeNotIn(List<BigDecimal> values) {
            addCriterion("SERVICE_FEE not in", values, "serviceFee");
            return (Criteria) this;
        }

        public Criteria andServiceFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SERVICE_FEE between", value1, value2, "serviceFee");
            return (Criteria) this;
        }

        public Criteria andServiceFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SERVICE_FEE not between", value1, value2, "serviceFee");
            return (Criteria) this;
        }

        public Criteria andCardFeeIsNull() {
            addCriterion("CARD_FEE is null");
            return (Criteria) this;
        }

        public Criteria andCardFeeIsNotNull() {
            addCriterion("CARD_FEE is not null");
            return (Criteria) this;
        }

        public Criteria andCardFeeEqualTo(BigDecimal value) {
            addCriterion("CARD_FEE =", value, "cardFee");
            return (Criteria) this;
        }

        public Criteria andCardFeeNotEqualTo(BigDecimal value) {
            addCriterion("CARD_FEE <>", value, "cardFee");
            return (Criteria) this;
        }

        public Criteria andCardFeeGreaterThan(BigDecimal value) {
            addCriterion("CARD_FEE >", value, "cardFee");
            return (Criteria) this;
        }

        public Criteria andCardFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CARD_FEE >=", value, "cardFee");
            return (Criteria) this;
        }

        public Criteria andCardFeeLessThan(BigDecimal value) {
            addCriterion("CARD_FEE <", value, "cardFee");
            return (Criteria) this;
        }

        public Criteria andCardFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CARD_FEE <=", value, "cardFee");
            return (Criteria) this;
        }

        public Criteria andCardFeeIn(List<BigDecimal> values) {
            addCriterion("CARD_FEE in", values, "cardFee");
            return (Criteria) this;
        }

        public Criteria andCardFeeNotIn(List<BigDecimal> values) {
            addCriterion("CARD_FEE not in", values, "cardFee");
            return (Criteria) this;
        }

        public Criteria andCardFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARD_FEE between", value1, value2, "cardFee");
            return (Criteria) this;
        }

        public Criteria andCardFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARD_FEE not between", value1, value2, "cardFee");
            return (Criteria) this;
        }

        public Criteria andFeeQuantumIsNull() {
            addCriterion("FEE_QUANTUM is null");
            return (Criteria) this;
        }

        public Criteria andFeeQuantumIsNotNull() {
            addCriterion("FEE_QUANTUM is not null");
            return (Criteria) this;
        }

        public Criteria andFeeQuantumEqualTo(String value) {
            addCriterion("FEE_QUANTUM =", value, "feeQuantum");
            return (Criteria) this;
        }

        public Criteria andFeeQuantumNotEqualTo(String value) {
            addCriterion("FEE_QUANTUM <>", value, "feeQuantum");
            return (Criteria) this;
        }

        public Criteria andFeeQuantumGreaterThan(String value) {
            addCriterion("FEE_QUANTUM >", value, "feeQuantum");
            return (Criteria) this;
        }

        public Criteria andFeeQuantumGreaterThanOrEqualTo(String value) {
            addCriterion("FEE_QUANTUM >=", value, "feeQuantum");
            return (Criteria) this;
        }

        public Criteria andFeeQuantumLessThan(String value) {
            addCriterion("FEE_QUANTUM <", value, "feeQuantum");
            return (Criteria) this;
        }

        public Criteria andFeeQuantumLessThanOrEqualTo(String value) {
            addCriterion("FEE_QUANTUM <=", value, "feeQuantum");
            return (Criteria) this;
        }

        public Criteria andFeeQuantumLike(String value) {
            addCriterion("FEE_QUANTUM like", value, "feeQuantum");
            return (Criteria) this;
        }

        public Criteria andFeeQuantumNotLike(String value) {
            addCriterion("FEE_QUANTUM not like", value, "feeQuantum");
            return (Criteria) this;
        }

        public Criteria andFeeQuantumIn(List<String> values) {
            addCriterion("FEE_QUANTUM in", values, "feeQuantum");
            return (Criteria) this;
        }

        public Criteria andFeeQuantumNotIn(List<String> values) {
            addCriterion("FEE_QUANTUM not in", values, "feeQuantum");
            return (Criteria) this;
        }

        public Criteria andFeeQuantumBetween(String value1, String value2) {
            addCriterion("FEE_QUANTUM between", value1, value2, "feeQuantum");
            return (Criteria) this;
        }

        public Criteria andFeeQuantumNotBetween(String value1, String value2) {
            addCriterion("FEE_QUANTUM not between", value1, value2, "feeQuantum");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion("REMARKS is null");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion("REMARKS is not null");
            return (Criteria) this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion("REMARKS =", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion("REMARKS <>", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion("REMARKS >", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("REMARKS >=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion("REMARKS <", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion("REMARKS <=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLike(String value) {
            addCriterion("REMARKS like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotLike(String value) {
            addCriterion("REMARKS not like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksIn(List<String> values) {
            addCriterion("REMARKS in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotIn(List<String> values) {
            addCriterion("REMARKS not in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion("REMARKS between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion("REMARKS not between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andServiceFee2IsNull() {
            addCriterion("SERVICE_FEE2 is null");
            return (Criteria) this;
        }

        public Criteria andServiceFee2IsNotNull() {
            addCriterion("SERVICE_FEE2 is not null");
            return (Criteria) this;
        }

        public Criteria andServiceFee2EqualTo(BigDecimal value) {
            addCriterion("SERVICE_FEE2 =", value, "serviceFee2");
            return (Criteria) this;
        }

        public Criteria andServiceFee2NotEqualTo(BigDecimal value) {
            addCriterion("SERVICE_FEE2 <>", value, "serviceFee2");
            return (Criteria) this;
        }

        public Criteria andServiceFee2GreaterThan(BigDecimal value) {
            addCriterion("SERVICE_FEE2 >", value, "serviceFee2");
            return (Criteria) this;
        }

        public Criteria andServiceFee2GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SERVICE_FEE2 >=", value, "serviceFee2");
            return (Criteria) this;
        }

        public Criteria andServiceFee2LessThan(BigDecimal value) {
            addCriterion("SERVICE_FEE2 <", value, "serviceFee2");
            return (Criteria) this;
        }

        public Criteria andServiceFee2LessThanOrEqualTo(BigDecimal value) {
            addCriterion("SERVICE_FEE2 <=", value, "serviceFee2");
            return (Criteria) this;
        }

        public Criteria andServiceFee2In(List<BigDecimal> values) {
            addCriterion("SERVICE_FEE2 in", values, "serviceFee2");
            return (Criteria) this;
        }

        public Criteria andServiceFee2NotIn(List<BigDecimal> values) {
            addCriterion("SERVICE_FEE2 not in", values, "serviceFee2");
            return (Criteria) this;
        }

        public Criteria andServiceFee2Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("SERVICE_FEE2 between", value1, value2, "serviceFee2");
            return (Criteria) this;
        }

        public Criteria andServiceFee2NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SERVICE_FEE2 not between", value1, value2, "serviceFee2");
            return (Criteria) this;
        }

        public Criteria andFeeQuantum2IsNull() {
            addCriterion("FEE_QUANTUM2 is null");
            return (Criteria) this;
        }

        public Criteria andFeeQuantum2IsNotNull() {
            addCriterion("FEE_QUANTUM2 is not null");
            return (Criteria) this;
        }

        public Criteria andFeeQuantum2EqualTo(String value) {
            addCriterion("FEE_QUANTUM2 =", value, "feeQuantum2");
            return (Criteria) this;
        }

        public Criteria andFeeQuantum2NotEqualTo(String value) {
            addCriterion("FEE_QUANTUM2 <>", value, "feeQuantum2");
            return (Criteria) this;
        }

        public Criteria andFeeQuantum2GreaterThan(String value) {
            addCriterion("FEE_QUANTUM2 >", value, "feeQuantum2");
            return (Criteria) this;
        }

        public Criteria andFeeQuantum2GreaterThanOrEqualTo(String value) {
            addCriterion("FEE_QUANTUM2 >=", value, "feeQuantum2");
            return (Criteria) this;
        }

        public Criteria andFeeQuantum2LessThan(String value) {
            addCriterion("FEE_QUANTUM2 <", value, "feeQuantum2");
            return (Criteria) this;
        }

        public Criteria andFeeQuantum2LessThanOrEqualTo(String value) {
            addCriterion("FEE_QUANTUM2 <=", value, "feeQuantum2");
            return (Criteria) this;
        }

        public Criteria andFeeQuantum2Like(String value) {
            addCriterion("FEE_QUANTUM2 like", value, "feeQuantum2");
            return (Criteria) this;
        }

        public Criteria andFeeQuantum2NotLike(String value) {
            addCriterion("FEE_QUANTUM2 not like", value, "feeQuantum2");
            return (Criteria) this;
        }

        public Criteria andFeeQuantum2In(List<String> values) {
            addCriterion("FEE_QUANTUM2 in", values, "feeQuantum2");
            return (Criteria) this;
        }

        public Criteria andFeeQuantum2NotIn(List<String> values) {
            addCriterion("FEE_QUANTUM2 not in", values, "feeQuantum2");
            return (Criteria) this;
        }

        public Criteria andFeeQuantum2Between(String value1, String value2) {
            addCriterion("FEE_QUANTUM2 between", value1, value2, "feeQuantum2");
            return (Criteria) this;
        }

        public Criteria andFeeQuantum2NotBetween(String value1, String value2) {
            addCriterion("FEE_QUANTUM2 not between", value1, value2, "feeQuantum2");
            return (Criteria) this;
        }

        public Criteria andDbcd2IsNull() {
            addCriterion("DBCD2 is null");
            return (Criteria) this;
        }

        public Criteria andDbcd2IsNotNull() {
            addCriterion("DBCD2 is not null");
            return (Criteria) this;
        }

        public Criteria andDbcd2EqualTo(String value) {
            addCriterion("DBCD2 =", value, "dbcd2");
            return (Criteria) this;
        }

        public Criteria andDbcd2NotEqualTo(String value) {
            addCriterion("DBCD2 <>", value, "dbcd2");
            return (Criteria) this;
        }

        public Criteria andDbcd2GreaterThan(String value) {
            addCriterion("DBCD2 >", value, "dbcd2");
            return (Criteria) this;
        }

        public Criteria andDbcd2GreaterThanOrEqualTo(String value) {
            addCriterion("DBCD2 >=", value, "dbcd2");
            return (Criteria) this;
        }

        public Criteria andDbcd2LessThan(String value) {
            addCriterion("DBCD2 <", value, "dbcd2");
            return (Criteria) this;
        }

        public Criteria andDbcd2LessThanOrEqualTo(String value) {
            addCriterion("DBCD2 <=", value, "dbcd2");
            return (Criteria) this;
        }

        public Criteria andDbcd2Like(String value) {
            addCriterion("DBCD2 like", value, "dbcd2");
            return (Criteria) this;
        }

        public Criteria andDbcd2NotLike(String value) {
            addCriterion("DBCD2 not like", value, "dbcd2");
            return (Criteria) this;
        }

        public Criteria andDbcd2In(List<String> values) {
            addCriterion("DBCD2 in", values, "dbcd2");
            return (Criteria) this;
        }

        public Criteria andDbcd2NotIn(List<String> values) {
            addCriterion("DBCD2 not in", values, "dbcd2");
            return (Criteria) this;
        }

        public Criteria andDbcd2Between(String value1, String value2) {
            addCriterion("DBCD2 between", value1, value2, "dbcd2");
            return (Criteria) this;
        }

        public Criteria andDbcd2NotBetween(String value1, String value2) {
            addCriterion("DBCD2 not between", value1, value2, "dbcd2");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentIsNull() {
            addCriterion("REIMBURSEMENT_PAYMENT is null");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentIsNotNull() {
            addCriterion("REIMBURSEMENT_PAYMENT is not null");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentEqualTo(String value) {
            addCriterion("REIMBURSEMENT_PAYMENT =", value, "reimbursementPayment");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentNotEqualTo(String value) {
            addCriterion("REIMBURSEMENT_PAYMENT <>", value, "reimbursementPayment");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentGreaterThan(String value) {
            addCriterion("REIMBURSEMENT_PAYMENT >", value, "reimbursementPayment");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentGreaterThanOrEqualTo(String value) {
            addCriterion("REIMBURSEMENT_PAYMENT >=", value, "reimbursementPayment");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentLessThan(String value) {
            addCriterion("REIMBURSEMENT_PAYMENT <", value, "reimbursementPayment");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentLessThanOrEqualTo(String value) {
            addCriterion("REIMBURSEMENT_PAYMENT <=", value, "reimbursementPayment");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentLike(String value) {
            addCriterion("REIMBURSEMENT_PAYMENT like", value, "reimbursementPayment");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentNotLike(String value) {
            addCriterion("REIMBURSEMENT_PAYMENT not like", value, "reimbursementPayment");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentIn(List<String> values) {
            addCriterion("REIMBURSEMENT_PAYMENT in", values, "reimbursementPayment");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentNotIn(List<String> values) {
            addCriterion("REIMBURSEMENT_PAYMENT not in", values, "reimbursementPayment");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentBetween(String value1, String value2) {
            addCriterion("REIMBURSEMENT_PAYMENT between", value1, value2, "reimbursementPayment");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentNotBetween(String value1, String value2) {
            addCriterion("REIMBURSEMENT_PAYMENT not between", value1, value2, "reimbursementPayment");
            return (Criteria) this;
        }

        public Criteria andEnglishNameIsNull() {
            addCriterion("ENGLISH_NAME is null");
            return (Criteria) this;
        }

        public Criteria andEnglishNameIsNotNull() {
            addCriterion("ENGLISH_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andEnglishNameEqualTo(String value) {
            addCriterion("ENGLISH_NAME =", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameNotEqualTo(String value) {
            addCriterion("ENGLISH_NAME <>", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameGreaterThan(String value) {
            addCriterion("ENGLISH_NAME >", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameGreaterThanOrEqualTo(String value) {
            addCriterion("ENGLISH_NAME >=", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameLessThan(String value) {
            addCriterion("ENGLISH_NAME <", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameLessThanOrEqualTo(String value) {
            addCriterion("ENGLISH_NAME <=", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameLike(String value) {
            addCriterion("ENGLISH_NAME like", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameNotLike(String value) {
            addCriterion("ENGLISH_NAME not like", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameIn(List<String> values) {
            addCriterion("ENGLISH_NAME in", values, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameNotIn(List<String> values) {
            addCriterion("ENGLISH_NAME not in", values, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameBetween(String value1, String value2) {
            addCriterion("ENGLISH_NAME between", value1, value2, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameNotBetween(String value1, String value2) {
            addCriterion("ENGLISH_NAME not between", value1, value2, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrIsNull() {
            addCriterion("ENGLISH_ADDR is null");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrIsNotNull() {
            addCriterion("ENGLISH_ADDR is not null");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrEqualTo(String value) {
            addCriterion("ENGLISH_ADDR =", value, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrNotEqualTo(String value) {
            addCriterion("ENGLISH_ADDR <>", value, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrGreaterThan(String value) {
            addCriterion("ENGLISH_ADDR >", value, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrGreaterThanOrEqualTo(String value) {
            addCriterion("ENGLISH_ADDR >=", value, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrLessThan(String value) {
            addCriterion("ENGLISH_ADDR <", value, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrLessThanOrEqualTo(String value) {
            addCriterion("ENGLISH_ADDR <=", value, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrLike(String value) {
            addCriterion("ENGLISH_ADDR like", value, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrNotLike(String value) {
            addCriterion("ENGLISH_ADDR not like", value, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrIn(List<String> values) {
            addCriterion("ENGLISH_ADDR in", values, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrNotIn(List<String> values) {
            addCriterion("ENGLISH_ADDR not in", values, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrBetween(String value1, String value2) {
            addCriterion("ENGLISH_ADDR between", value1, value2, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrNotBetween(String value1, String value2) {
            addCriterion("ENGLISH_ADDR not between", value1, value2, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andCashlessPaymentIsNull() {
            addCriterion("CASHLESS_PAYMENT is null");
            return (Criteria) this;
        }

        public Criteria andCashlessPaymentIsNotNull() {
            addCriterion("CASHLESS_PAYMENT is not null");
            return (Criteria) this;
        }

        public Criteria andCashlessPaymentEqualTo(String value) {
            addCriterion("CASHLESS_PAYMENT =", value, "cashlessPayment");
            return (Criteria) this;
        }

        public Criteria andCashlessPaymentNotEqualTo(String value) {
            addCriterion("CASHLESS_PAYMENT <>", value, "cashlessPayment");
            return (Criteria) this;
        }

        public Criteria andCashlessPaymentGreaterThan(String value) {
            addCriterion("CASHLESS_PAYMENT >", value, "cashlessPayment");
            return (Criteria) this;
        }

        public Criteria andCashlessPaymentGreaterThanOrEqualTo(String value) {
            addCriterion("CASHLESS_PAYMENT >=", value, "cashlessPayment");
            return (Criteria) this;
        }

        public Criteria andCashlessPaymentLessThan(String value) {
            addCriterion("CASHLESS_PAYMENT <", value, "cashlessPayment");
            return (Criteria) this;
        }

        public Criteria andCashlessPaymentLessThanOrEqualTo(String value) {
            addCriterion("CASHLESS_PAYMENT <=", value, "cashlessPayment");
            return (Criteria) this;
        }

        public Criteria andCashlessPaymentLike(String value) {
            addCriterion("CASHLESS_PAYMENT like", value, "cashlessPayment");
            return (Criteria) this;
        }

        public Criteria andCashlessPaymentNotLike(String value) {
            addCriterion("CASHLESS_PAYMENT not like", value, "cashlessPayment");
            return (Criteria) this;
        }

        public Criteria andCashlessPaymentIn(List<String> values) {
            addCriterion("CASHLESS_PAYMENT in", values, "cashlessPayment");
            return (Criteria) this;
        }

        public Criteria andCashlessPaymentNotIn(List<String> values) {
            addCriterion("CASHLESS_PAYMENT not in", values, "cashlessPayment");
            return (Criteria) this;
        }

        public Criteria andCashlessPaymentBetween(String value1, String value2) {
            addCriterion("CASHLESS_PAYMENT between", value1, value2, "cashlessPayment");
            return (Criteria) this;
        }

        public Criteria andCashlessPaymentNotBetween(String value1, String value2) {
            addCriterion("CASHLESS_PAYMENT not between", value1, value2, "cashlessPayment");
            return (Criteria) this;
        }

        public Criteria andNextbillDateIsNull() {
            addCriterion("NEXTBILL_DATE is null");
            return (Criteria) this;
        }

        public Criteria andNextbillDateIsNotNull() {
            addCriterion("NEXTBILL_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andNextbillDateEqualTo(Date value) {
            addCriterion("NEXTBILL_DATE =", value, "nextbillDate");
            return (Criteria) this;
        }

        public Criteria andNextbillDateNotEqualTo(Date value) {
            addCriterion("NEXTBILL_DATE <>", value, "nextbillDate");
            return (Criteria) this;
        }

        public Criteria andNextbillDateGreaterThan(Date value) {
            addCriterion("NEXTBILL_DATE >", value, "nextbillDate");
            return (Criteria) this;
        }

        public Criteria andNextbillDateGreaterThanOrEqualTo(Date value) {
            addCriterion("NEXTBILL_DATE >=", value, "nextbillDate");
            return (Criteria) this;
        }

        public Criteria andNextbillDateLessThan(Date value) {
            addCriterion("NEXTBILL_DATE <", value, "nextbillDate");
            return (Criteria) this;
        }

        public Criteria andNextbillDateLessThanOrEqualTo(Date value) {
            addCriterion("NEXTBILL_DATE <=", value, "nextbillDate");
            return (Criteria) this;
        }

        public Criteria andNextbillDateIn(List<Date> values) {
            addCriterion("NEXTBILL_DATE in", values, "nextbillDate");
            return (Criteria) this;
        }

        public Criteria andNextbillDateNotIn(List<Date> values) {
            addCriterion("NEXTBILL_DATE not in", values, "nextbillDate");
            return (Criteria) this;
        }

        public Criteria andNextbillDateBetween(Date value1, Date value2) {
            addCriterion("NEXTBILL_DATE between", value1, value2, "nextbillDate");
            return (Criteria) this;
        }

        public Criteria andNextbillDateNotBetween(Date value1, Date value2) {
            addCriterion("NEXTBILL_DATE not between", value1, value2, "nextbillDate");
            return (Criteria) this;
        }

        public Criteria andNetworkCodeIsNull() {
            addCriterion("NETWORK_CODE is null");
            return (Criteria) this;
        }

        public Criteria andNetworkCodeIsNotNull() {
            addCriterion("NETWORK_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andNetworkCodeEqualTo(String value) {
            addCriterion("NETWORK_CODE =", value, "networkCode");
            return (Criteria) this;
        }

        public Criteria andNetworkCodeNotEqualTo(String value) {
            addCriterion("NETWORK_CODE <>", value, "networkCode");
            return (Criteria) this;
        }

        public Criteria andNetworkCodeGreaterThan(String value) {
            addCriterion("NETWORK_CODE >", value, "networkCode");
            return (Criteria) this;
        }

        public Criteria andNetworkCodeGreaterThanOrEqualTo(String value) {
            addCriterion("NETWORK_CODE >=", value, "networkCode");
            return (Criteria) this;
        }

        public Criteria andNetworkCodeLessThan(String value) {
            addCriterion("NETWORK_CODE <", value, "networkCode");
            return (Criteria) this;
        }

        public Criteria andNetworkCodeLessThanOrEqualTo(String value) {
            addCriterion("NETWORK_CODE <=", value, "networkCode");
            return (Criteria) this;
        }

        public Criteria andNetworkCodeLike(String value) {
            addCriterion("NETWORK_CODE like", value, "networkCode");
            return (Criteria) this;
        }

        public Criteria andNetworkCodeNotLike(String value) {
            addCriterion("NETWORK_CODE not like", value, "networkCode");
            return (Criteria) this;
        }

        public Criteria andNetworkCodeIn(List<String> values) {
            addCriterion("NETWORK_CODE in", values, "networkCode");
            return (Criteria) this;
        }

        public Criteria andNetworkCodeNotIn(List<String> values) {
            addCriterion("NETWORK_CODE not in", values, "networkCode");
            return (Criteria) this;
        }

        public Criteria andNetworkCodeBetween(String value1, String value2) {
            addCriterion("NETWORK_CODE between", value1, value2, "networkCode");
            return (Criteria) this;
        }

        public Criteria andNetworkCodeNotBetween(String value1, String value2) {
            addCriterion("NETWORK_CODE not between", value1, value2, "networkCode");
            return (Criteria) this;
        }

        public Criteria andCentreCodeIsNull() {
            addCriterion("CENTRE_CODE is null");
            return (Criteria) this;
        }

        public Criteria andCentreCodeIsNotNull() {
            addCriterion("CENTRE_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCentreCodeEqualTo(String value) {
            addCriterion("CENTRE_CODE =", value, "centreCode");
            return (Criteria) this;
        }

        public Criteria andCentreCodeNotEqualTo(String value) {
            addCriterion("CENTRE_CODE <>", value, "centreCode");
            return (Criteria) this;
        }

        public Criteria andCentreCodeGreaterThan(String value) {
            addCriterion("CENTRE_CODE >", value, "centreCode");
            return (Criteria) this;
        }

        public Criteria andCentreCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CENTRE_CODE >=", value, "centreCode");
            return (Criteria) this;
        }

        public Criteria andCentreCodeLessThan(String value) {
            addCriterion("CENTRE_CODE <", value, "centreCode");
            return (Criteria) this;
        }

        public Criteria andCentreCodeLessThanOrEqualTo(String value) {
            addCriterion("CENTRE_CODE <=", value, "centreCode");
            return (Criteria) this;
        }

        public Criteria andCentreCodeLike(String value) {
            addCriterion("CENTRE_CODE like", value, "centreCode");
            return (Criteria) this;
        }

        public Criteria andCentreCodeNotLike(String value) {
            addCriterion("CENTRE_CODE not like", value, "centreCode");
            return (Criteria) this;
        }

        public Criteria andCentreCodeIn(List<String> values) {
            addCriterion("CENTRE_CODE in", values, "centreCode");
            return (Criteria) this;
        }

        public Criteria andCentreCodeNotIn(List<String> values) {
            addCriterion("CENTRE_CODE not in", values, "centreCode");
            return (Criteria) this;
        }

        public Criteria andCentreCodeBetween(String value1, String value2) {
            addCriterion("CENTRE_CODE between", value1, value2, "centreCode");
            return (Criteria) this;
        }

        public Criteria andCentreCodeNotBetween(String value1, String value2) {
            addCriterion("CENTRE_CODE not between", value1, value2, "centreCode");
            return (Criteria) this;
        }

        public Criteria andMemberDbcdIsNull() {
            addCriterion("MEMBER_DBCD is null");
            return (Criteria) this;
        }

        public Criteria andMemberDbcdIsNotNull() {
            addCriterion("MEMBER_DBCD is not null");
            return (Criteria) this;
        }

        public Criteria andMemberDbcdEqualTo(String value) {
            addCriterion("MEMBER_DBCD =", value, "memberDbcd");
            return (Criteria) this;
        }

        public Criteria andMemberDbcdNotEqualTo(String value) {
            addCriterion("MEMBER_DBCD <>", value, "memberDbcd");
            return (Criteria) this;
        }

        public Criteria andMemberDbcdGreaterThan(String value) {
            addCriterion("MEMBER_DBCD >", value, "memberDbcd");
            return (Criteria) this;
        }

        public Criteria andMemberDbcdGreaterThanOrEqualTo(String value) {
            addCriterion("MEMBER_DBCD >=", value, "memberDbcd");
            return (Criteria) this;
        }

        public Criteria andMemberDbcdLessThan(String value) {
            addCriterion("MEMBER_DBCD <", value, "memberDbcd");
            return (Criteria) this;
        }

        public Criteria andMemberDbcdLessThanOrEqualTo(String value) {
            addCriterion("MEMBER_DBCD <=", value, "memberDbcd");
            return (Criteria) this;
        }

        public Criteria andMemberDbcdLike(String value) {
            addCriterion("MEMBER_DBCD like", value, "memberDbcd");
            return (Criteria) this;
        }

        public Criteria andMemberDbcdNotLike(String value) {
            addCriterion("MEMBER_DBCD not like", value, "memberDbcd");
            return (Criteria) this;
        }

        public Criteria andMemberDbcdIn(List<String> values) {
            addCriterion("MEMBER_DBCD in", values, "memberDbcd");
            return (Criteria) this;
        }

        public Criteria andMemberDbcdNotIn(List<String> values) {
            addCriterion("MEMBER_DBCD not in", values, "memberDbcd");
            return (Criteria) this;
        }

        public Criteria andMemberDbcdBetween(String value1, String value2) {
            addCriterion("MEMBER_DBCD between", value1, value2, "memberDbcd");
            return (Criteria) this;
        }

        public Criteria andMemberDbcdNotBetween(String value1, String value2) {
            addCriterion("MEMBER_DBCD not between", value1, value2, "memberDbcd");
            return (Criteria) this;
        }

        public Criteria andMemberCrcdIsNull() {
            addCriterion("MEMBER_CRCD is null");
            return (Criteria) this;
        }

        public Criteria andMemberCrcdIsNotNull() {
            addCriterion("MEMBER_CRCD is not null");
            return (Criteria) this;
        }

        public Criteria andMemberCrcdEqualTo(String value) {
            addCriterion("MEMBER_CRCD =", value, "memberCrcd");
            return (Criteria) this;
        }

        public Criteria andMemberCrcdNotEqualTo(String value) {
            addCriterion("MEMBER_CRCD <>", value, "memberCrcd");
            return (Criteria) this;
        }

        public Criteria andMemberCrcdGreaterThan(String value) {
            addCriterion("MEMBER_CRCD >", value, "memberCrcd");
            return (Criteria) this;
        }

        public Criteria andMemberCrcdGreaterThanOrEqualTo(String value) {
            addCriterion("MEMBER_CRCD >=", value, "memberCrcd");
            return (Criteria) this;
        }

        public Criteria andMemberCrcdLessThan(String value) {
            addCriterion("MEMBER_CRCD <", value, "memberCrcd");
            return (Criteria) this;
        }

        public Criteria andMemberCrcdLessThanOrEqualTo(String value) {
            addCriterion("MEMBER_CRCD <=", value, "memberCrcd");
            return (Criteria) this;
        }

        public Criteria andMemberCrcdLike(String value) {
            addCriterion("MEMBER_CRCD like", value, "memberCrcd");
            return (Criteria) this;
        }

        public Criteria andMemberCrcdNotLike(String value) {
            addCriterion("MEMBER_CRCD not like", value, "memberCrcd");
            return (Criteria) this;
        }

        public Criteria andMemberCrcdIn(List<String> values) {
            addCriterion("MEMBER_CRCD in", values, "memberCrcd");
            return (Criteria) this;
        }

        public Criteria andMemberCrcdNotIn(List<String> values) {
            addCriterion("MEMBER_CRCD not in", values, "memberCrcd");
            return (Criteria) this;
        }

        public Criteria andMemberCrcdBetween(String value1, String value2) {
            addCriterion("MEMBER_CRCD between", value1, value2, "memberCrcd");
            return (Criteria) this;
        }

        public Criteria andMemberCrcdNotBetween(String value1, String value2) {
            addCriterion("MEMBER_CRCD not between", value1, value2, "memberCrcd");
            return (Criteria) this;
        }

        public Criteria andVerifyOpdocIsNull() {
            addCriterion("VERIFY_OPDOC is null");
            return (Criteria) this;
        }

        public Criteria andVerifyOpdocIsNotNull() {
            addCriterion("VERIFY_OPDOC is not null");
            return (Criteria) this;
        }

        public Criteria andVerifyOpdocEqualTo(String value) {
            addCriterion("VERIFY_OPDOC =", value, "verifyOpdoc");
            return (Criteria) this;
        }

        public Criteria andVerifyOpdocNotEqualTo(String value) {
            addCriterion("VERIFY_OPDOC <>", value, "verifyOpdoc");
            return (Criteria) this;
        }

        public Criteria andVerifyOpdocGreaterThan(String value) {
            addCriterion("VERIFY_OPDOC >", value, "verifyOpdoc");
            return (Criteria) this;
        }

        public Criteria andVerifyOpdocGreaterThanOrEqualTo(String value) {
            addCriterion("VERIFY_OPDOC >=", value, "verifyOpdoc");
            return (Criteria) this;
        }

        public Criteria andVerifyOpdocLessThan(String value) {
            addCriterion("VERIFY_OPDOC <", value, "verifyOpdoc");
            return (Criteria) this;
        }

        public Criteria andVerifyOpdocLessThanOrEqualTo(String value) {
            addCriterion("VERIFY_OPDOC <=", value, "verifyOpdoc");
            return (Criteria) this;
        }

        public Criteria andVerifyOpdocLike(String value) {
            addCriterion("VERIFY_OPDOC like", value, "verifyOpdoc");
            return (Criteria) this;
        }

        public Criteria andVerifyOpdocNotLike(String value) {
            addCriterion("VERIFY_OPDOC not like", value, "verifyOpdoc");
            return (Criteria) this;
        }

        public Criteria andVerifyOpdocIn(List<String> values) {
            addCriterion("VERIFY_OPDOC in", values, "verifyOpdoc");
            return (Criteria) this;
        }

        public Criteria andVerifyOpdocNotIn(List<String> values) {
            addCriterion("VERIFY_OPDOC not in", values, "verifyOpdoc");
            return (Criteria) this;
        }

        public Criteria andVerifyOpdocBetween(String value1, String value2) {
            addCriterion("VERIFY_OPDOC between", value1, value2, "verifyOpdoc");
            return (Criteria) this;
        }

        public Criteria andVerifyOpdocNotBetween(String value1, String value2) {
            addCriterion("VERIFY_OPDOC not between", value1, value2, "verifyOpdoc");
            return (Criteria) this;
        }

        public Criteria andClaimsDbcdIsNull() {
            addCriterion("CLAIMS_DBCD is null");
            return (Criteria) this;
        }

        public Criteria andClaimsDbcdIsNotNull() {
            addCriterion("CLAIMS_DBCD is not null");
            return (Criteria) this;
        }

        public Criteria andClaimsDbcdEqualTo(String value) {
            addCriterion("CLAIMS_DBCD =", value, "claimsDbcd");
            return (Criteria) this;
        }

        public Criteria andClaimsDbcdNotEqualTo(String value) {
            addCriterion("CLAIMS_DBCD <>", value, "claimsDbcd");
            return (Criteria) this;
        }

        public Criteria andClaimsDbcdGreaterThan(String value) {
            addCriterion("CLAIMS_DBCD >", value, "claimsDbcd");
            return (Criteria) this;
        }

        public Criteria andClaimsDbcdGreaterThanOrEqualTo(String value) {
            addCriterion("CLAIMS_DBCD >=", value, "claimsDbcd");
            return (Criteria) this;
        }

        public Criteria andClaimsDbcdLessThan(String value) {
            addCriterion("CLAIMS_DBCD <", value, "claimsDbcd");
            return (Criteria) this;
        }

        public Criteria andClaimsDbcdLessThanOrEqualTo(String value) {
            addCriterion("CLAIMS_DBCD <=", value, "claimsDbcd");
            return (Criteria) this;
        }

        public Criteria andClaimsDbcdLike(String value) {
            addCriterion("CLAIMS_DBCD like", value, "claimsDbcd");
            return (Criteria) this;
        }

        public Criteria andClaimsDbcdNotLike(String value) {
            addCriterion("CLAIMS_DBCD not like", value, "claimsDbcd");
            return (Criteria) this;
        }

        public Criteria andClaimsDbcdIn(List<String> values) {
            addCriterion("CLAIMS_DBCD in", values, "claimsDbcd");
            return (Criteria) this;
        }

        public Criteria andClaimsDbcdNotIn(List<String> values) {
            addCriterion("CLAIMS_DBCD not in", values, "claimsDbcd");
            return (Criteria) this;
        }

        public Criteria andClaimsDbcdBetween(String value1, String value2) {
            addCriterion("CLAIMS_DBCD between", value1, value2, "claimsDbcd");
            return (Criteria) this;
        }

        public Criteria andClaimsDbcdNotBetween(String value1, String value2) {
            addCriterion("CLAIMS_DBCD not between", value1, value2, "claimsDbcd");
            return (Criteria) this;
        }

        public Criteria andBillCardFeeIsNull() {
            addCriterion("BILL_CARD_FEE is null");
            return (Criteria) this;
        }

        public Criteria andBillCardFeeIsNotNull() {
            addCriterion("BILL_CARD_FEE is not null");
            return (Criteria) this;
        }

        public Criteria andBillCardFeeEqualTo(String value) {
            addCriterion("BILL_CARD_FEE =", value, "billCardFee");
            return (Criteria) this;
        }

        public Criteria andBillCardFeeNotEqualTo(String value) {
            addCriterion("BILL_CARD_FEE <>", value, "billCardFee");
            return (Criteria) this;
        }

        public Criteria andBillCardFeeGreaterThan(String value) {
            addCriterion("BILL_CARD_FEE >", value, "billCardFee");
            return (Criteria) this;
        }

        public Criteria andBillCardFeeGreaterThanOrEqualTo(String value) {
            addCriterion("BILL_CARD_FEE >=", value, "billCardFee");
            return (Criteria) this;
        }

        public Criteria andBillCardFeeLessThan(String value) {
            addCriterion("BILL_CARD_FEE <", value, "billCardFee");
            return (Criteria) this;
        }

        public Criteria andBillCardFeeLessThanOrEqualTo(String value) {
            addCriterion("BILL_CARD_FEE <=", value, "billCardFee");
            return (Criteria) this;
        }

        public Criteria andBillCardFeeLike(String value) {
            addCriterion("BILL_CARD_FEE like", value, "billCardFee");
            return (Criteria) this;
        }

        public Criteria andBillCardFeeNotLike(String value) {
            addCriterion("BILL_CARD_FEE not like", value, "billCardFee");
            return (Criteria) this;
        }

        public Criteria andBillCardFeeIn(List<String> values) {
            addCriterion("BILL_CARD_FEE in", values, "billCardFee");
            return (Criteria) this;
        }

        public Criteria andBillCardFeeNotIn(List<String> values) {
            addCriterion("BILL_CARD_FEE not in", values, "billCardFee");
            return (Criteria) this;
        }

        public Criteria andBillCardFeeBetween(String value1, String value2) {
            addCriterion("BILL_CARD_FEE between", value1, value2, "billCardFee");
            return (Criteria) this;
        }

        public Criteria andBillCardFeeNotBetween(String value1, String value2) {
            addCriterion("BILL_CARD_FEE not between", value1, value2, "billCardFee");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentModeIsNull() {
            addCriterion("REIMBURSEMENT_PAYMENT_MODE is null");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentModeIsNotNull() {
            addCriterion("REIMBURSEMENT_PAYMENT_MODE is not null");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentModeEqualTo(String value) {
            addCriterion("REIMBURSEMENT_PAYMENT_MODE =", value, "reimbursementPaymentMode");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentModeNotEqualTo(String value) {
            addCriterion("REIMBURSEMENT_PAYMENT_MODE <>", value, "reimbursementPaymentMode");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentModeGreaterThan(String value) {
            addCriterion("REIMBURSEMENT_PAYMENT_MODE >", value, "reimbursementPaymentMode");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentModeGreaterThanOrEqualTo(String value) {
            addCriterion("REIMBURSEMENT_PAYMENT_MODE >=", value, "reimbursementPaymentMode");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentModeLessThan(String value) {
            addCriterion("REIMBURSEMENT_PAYMENT_MODE <", value, "reimbursementPaymentMode");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentModeLessThanOrEqualTo(String value) {
            addCriterion("REIMBURSEMENT_PAYMENT_MODE <=", value, "reimbursementPaymentMode");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentModeLike(String value) {
            addCriterion("REIMBURSEMENT_PAYMENT_MODE like", value, "reimbursementPaymentMode");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentModeNotLike(String value) {
            addCriterion("REIMBURSEMENT_PAYMENT_MODE not like", value, "reimbursementPaymentMode");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentModeIn(List<String> values) {
            addCriterion("REIMBURSEMENT_PAYMENT_MODE in", values, "reimbursementPaymentMode");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentModeNotIn(List<String> values) {
            addCriterion("REIMBURSEMENT_PAYMENT_MODE not in", values, "reimbursementPaymentMode");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentModeBetween(String value1, String value2) {
            addCriterion("REIMBURSEMENT_PAYMENT_MODE between", value1, value2, "reimbursementPaymentMode");
            return (Criteria) this;
        }

        public Criteria andReimbursementPaymentModeNotBetween(String value1, String value2) {
            addCriterion("REIMBURSEMENT_PAYMENT_MODE not between", value1, value2, "reimbursementPaymentMode");
            return (Criteria) this;
        }

        public Criteria andIndustryTypeIsNull() {
            addCriterion("INDUSTRY_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andIndustryTypeIsNotNull() {
            addCriterion("INDUSTRY_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andIndustryTypeEqualTo(String value) {
            addCriterion("INDUSTRY_TYPE =", value, "industryType");
            return (Criteria) this;
        }

        public Criteria andIndustryTypeNotEqualTo(String value) {
            addCriterion("INDUSTRY_TYPE <>", value, "industryType");
            return (Criteria) this;
        }

        public Criteria andIndustryTypeGreaterThan(String value) {
            addCriterion("INDUSTRY_TYPE >", value, "industryType");
            return (Criteria) this;
        }

        public Criteria andIndustryTypeGreaterThanOrEqualTo(String value) {
            addCriterion("INDUSTRY_TYPE >=", value, "industryType");
            return (Criteria) this;
        }

        public Criteria andIndustryTypeLessThan(String value) {
            addCriterion("INDUSTRY_TYPE <", value, "industryType");
            return (Criteria) this;
        }

        public Criteria andIndustryTypeLessThanOrEqualTo(String value) {
            addCriterion("INDUSTRY_TYPE <=", value, "industryType");
            return (Criteria) this;
        }

        public Criteria andIndustryTypeLike(String value) {
            addCriterion("INDUSTRY_TYPE like", value, "industryType");
            return (Criteria) this;
        }

        public Criteria andIndustryTypeNotLike(String value) {
            addCriterion("INDUSTRY_TYPE not like", value, "industryType");
            return (Criteria) this;
        }

        public Criteria andIndustryTypeIn(List<String> values) {
            addCriterion("INDUSTRY_TYPE in", values, "industryType");
            return (Criteria) this;
        }

        public Criteria andIndustryTypeNotIn(List<String> values) {
            addCriterion("INDUSTRY_TYPE not in", values, "industryType");
            return (Criteria) this;
        }

        public Criteria andIndustryTypeBetween(String value1, String value2) {
            addCriterion("INDUSTRY_TYPE between", value1, value2, "industryType");
            return (Criteria) this;
        }

        public Criteria andIndustryTypeNotBetween(String value1, String value2) {
            addCriterion("INDUSTRY_TYPE not between", value1, value2, "industryType");
            return (Criteria) this;
        }

        public Criteria andPaybankaccidIsNull() {
            addCriterion("PAYBANKACCID is null");
            return (Criteria) this;
        }

        public Criteria andPaybankaccidIsNotNull() {
            addCriterion("PAYBANKACCID is not null");
            return (Criteria) this;
        }

        public Criteria andPaybankaccidEqualTo(String value) {
            addCriterion("PAYBANKACCID =", value, "paybankaccid");
            return (Criteria) this;
        }

        public Criteria andPaybankaccidNotEqualTo(String value) {
            addCriterion("PAYBANKACCID <>", value, "paybankaccid");
            return (Criteria) this;
        }

        public Criteria andPaybankaccidGreaterThan(String value) {
            addCriterion("PAYBANKACCID >", value, "paybankaccid");
            return (Criteria) this;
        }

        public Criteria andPaybankaccidGreaterThanOrEqualTo(String value) {
            addCriterion("PAYBANKACCID >=", value, "paybankaccid");
            return (Criteria) this;
        }

        public Criteria andPaybankaccidLessThan(String value) {
            addCriterion("PAYBANKACCID <", value, "paybankaccid");
            return (Criteria) this;
        }

        public Criteria andPaybankaccidLessThanOrEqualTo(String value) {
            addCriterion("PAYBANKACCID <=", value, "paybankaccid");
            return (Criteria) this;
        }

        public Criteria andPaybankaccidLike(String value) {
            addCriterion("PAYBANKACCID like", value, "paybankaccid");
            return (Criteria) this;
        }

        public Criteria andPaybankaccidNotLike(String value) {
            addCriterion("PAYBANKACCID not like", value, "paybankaccid");
            return (Criteria) this;
        }

        public Criteria andPaybankaccidIn(List<String> values) {
            addCriterion("PAYBANKACCID in", values, "paybankaccid");
            return (Criteria) this;
        }

        public Criteria andPaybankaccidNotIn(List<String> values) {
            addCriterion("PAYBANKACCID not in", values, "paybankaccid");
            return (Criteria) this;
        }

        public Criteria andPaybankaccidBetween(String value1, String value2) {
            addCriterion("PAYBANKACCID between", value1, value2, "paybankaccid");
            return (Criteria) this;
        }

        public Criteria andPaybankaccidNotBetween(String value1, String value2) {
            addCriterion("PAYBANKACCID not between", value1, value2, "paybankaccid");
            return (Criteria) this;
        }

        public Criteria andApplyGstIsNull() {
            addCriterion("APPLY_GST is null");
            return (Criteria) this;
        }

        public Criteria andApplyGstIsNotNull() {
            addCriterion("APPLY_GST is not null");
            return (Criteria) this;
        }

        public Criteria andApplyGstEqualTo(String value) {
            addCriterion("APPLY_GST =", value, "applyGst");
            return (Criteria) this;
        }

        public Criteria andApplyGstNotEqualTo(String value) {
            addCriterion("APPLY_GST <>", value, "applyGst");
            return (Criteria) this;
        }

        public Criteria andApplyGstGreaterThan(String value) {
            addCriterion("APPLY_GST >", value, "applyGst");
            return (Criteria) this;
        }

        public Criteria andApplyGstGreaterThanOrEqualTo(String value) {
            addCriterion("APPLY_GST >=", value, "applyGst");
            return (Criteria) this;
        }

        public Criteria andApplyGstLessThan(String value) {
            addCriterion("APPLY_GST <", value, "applyGst");
            return (Criteria) this;
        }

        public Criteria andApplyGstLessThanOrEqualTo(String value) {
            addCriterion("APPLY_GST <=", value, "applyGst");
            return (Criteria) this;
        }

        public Criteria andApplyGstLike(String value) {
            addCriterion("APPLY_GST like", value, "applyGst");
            return (Criteria) this;
        }

        public Criteria andApplyGstNotLike(String value) {
            addCriterion("APPLY_GST not like", value, "applyGst");
            return (Criteria) this;
        }

        public Criteria andApplyGstIn(List<String> values) {
            addCriterion("APPLY_GST in", values, "applyGst");
            return (Criteria) this;
        }

        public Criteria andApplyGstNotIn(List<String> values) {
            addCriterion("APPLY_GST not in", values, "applyGst");
            return (Criteria) this;
        }

        public Criteria andApplyGstBetween(String value1, String value2) {
            addCriterion("APPLY_GST between", value1, value2, "applyGst");
            return (Criteria) this;
        }

        public Criteria andApplyGstNotBetween(String value1, String value2) {
            addCriterion("APPLY_GST not between", value1, value2, "applyGst");
            return (Criteria) this;
        }

        public Criteria andApplyVatIsNull() {
            addCriterion("APPLY_VAT is null");
            return (Criteria) this;
        }

        public Criteria andApplyVatIsNotNull() {
            addCriterion("APPLY_VAT is not null");
            return (Criteria) this;
        }

        public Criteria andApplyVatEqualTo(String value) {
            addCriterion("APPLY_VAT =", value, "applyVat");
            return (Criteria) this;
        }

        public Criteria andApplyVatNotEqualTo(String value) {
            addCriterion("APPLY_VAT <>", value, "applyVat");
            return (Criteria) this;
        }

        public Criteria andApplyVatGreaterThan(String value) {
            addCriterion("APPLY_VAT >", value, "applyVat");
            return (Criteria) this;
        }

        public Criteria andApplyVatGreaterThanOrEqualTo(String value) {
            addCriterion("APPLY_VAT >=", value, "applyVat");
            return (Criteria) this;
        }

        public Criteria andApplyVatLessThan(String value) {
            addCriterion("APPLY_VAT <", value, "applyVat");
            return (Criteria) this;
        }

        public Criteria andApplyVatLessThanOrEqualTo(String value) {
            addCriterion("APPLY_VAT <=", value, "applyVat");
            return (Criteria) this;
        }

        public Criteria andApplyVatLike(String value) {
            addCriterion("APPLY_VAT like", value, "applyVat");
            return (Criteria) this;
        }

        public Criteria andApplyVatNotLike(String value) {
            addCriterion("APPLY_VAT not like", value, "applyVat");
            return (Criteria) this;
        }

        public Criteria andApplyVatIn(List<String> values) {
            addCriterion("APPLY_VAT in", values, "applyVat");
            return (Criteria) this;
        }

        public Criteria andApplyVatNotIn(List<String> values) {
            addCriterion("APPLY_VAT not in", values, "applyVat");
            return (Criteria) this;
        }

        public Criteria andApplyVatBetween(String value1, String value2) {
            addCriterion("APPLY_VAT between", value1, value2, "applyVat");
            return (Criteria) this;
        }

        public Criteria andApplyVatNotBetween(String value1, String value2) {
            addCriterion("APPLY_VAT not between", value1, value2, "applyVat");
            return (Criteria) this;
        }

        public Criteria andCurrcdIsNull() {
            addCriterion("CURRCD is null");
            return (Criteria) this;
        }

        public Criteria andCurrcdIsNotNull() {
            addCriterion("CURRCD is not null");
            return (Criteria) this;
        }

        public Criteria andCurrcdEqualTo(String value) {
            addCriterion("CURRCD =", value, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdNotEqualTo(String value) {
            addCriterion("CURRCD <>", value, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdGreaterThan(String value) {
            addCriterion("CURRCD >", value, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdGreaterThanOrEqualTo(String value) {
            addCriterion("CURRCD >=", value, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdLessThan(String value) {
            addCriterion("CURRCD <", value, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdLessThanOrEqualTo(String value) {
            addCriterion("CURRCD <=", value, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdLike(String value) {
            addCriterion("CURRCD like", value, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdNotLike(String value) {
            addCriterion("CURRCD not like", value, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdIn(List<String> values) {
            addCriterion("CURRCD in", values, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdNotIn(List<String> values) {
            addCriterion("CURRCD not in", values, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdBetween(String value1, String value2) {
            addCriterion("CURRCD between", value1, value2, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdNotBetween(String value1, String value2) {
            addCriterion("CURRCD not between", value1, value2, "currcd");
            return (Criteria) this;
        }

        public Criteria andPayorCorpCodeIsNull() {
            addCriterion("PAYOR_CORP_CODE is null");
            return (Criteria) this;
        }

        public Criteria andPayorCorpCodeIsNotNull() {
            addCriterion("PAYOR_CORP_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andPayorCorpCodeEqualTo(String value) {
            addCriterion("PAYOR_CORP_CODE =", value, "payorCorpCode");
            return (Criteria) this;
        }

        public Criteria andPayorCorpCodeNotEqualTo(String value) {
            addCriterion("PAYOR_CORP_CODE <>", value, "payorCorpCode");
            return (Criteria) this;
        }

        public Criteria andPayorCorpCodeGreaterThan(String value) {
            addCriterion("PAYOR_CORP_CODE >", value, "payorCorpCode");
            return (Criteria) this;
        }

        public Criteria andPayorCorpCodeGreaterThanOrEqualTo(String value) {
            addCriterion("PAYOR_CORP_CODE >=", value, "payorCorpCode");
            return (Criteria) this;
        }

        public Criteria andPayorCorpCodeLessThan(String value) {
            addCriterion("PAYOR_CORP_CODE <", value, "payorCorpCode");
            return (Criteria) this;
        }

        public Criteria andPayorCorpCodeLessThanOrEqualTo(String value) {
            addCriterion("PAYOR_CORP_CODE <=", value, "payorCorpCode");
            return (Criteria) this;
        }

        public Criteria andPayorCorpCodeLike(String value) {
            addCriterion("PAYOR_CORP_CODE like", value, "payorCorpCode");
            return (Criteria) this;
        }

        public Criteria andPayorCorpCodeNotLike(String value) {
            addCriterion("PAYOR_CORP_CODE not like", value, "payorCorpCode");
            return (Criteria) this;
        }

        public Criteria andPayorCorpCodeIn(List<String> values) {
            addCriterion("PAYOR_CORP_CODE in", values, "payorCorpCode");
            return (Criteria) this;
        }

        public Criteria andPayorCorpCodeNotIn(List<String> values) {
            addCriterion("PAYOR_CORP_CODE not in", values, "payorCorpCode");
            return (Criteria) this;
        }

        public Criteria andPayorCorpCodeBetween(String value1, String value2) {
            addCriterion("PAYOR_CORP_CODE between", value1, value2, "payorCorpCode");
            return (Criteria) this;
        }

        public Criteria andPayorCorpCodeNotBetween(String value1, String value2) {
            addCriterion("PAYOR_CORP_CODE not between", value1, value2, "payorCorpCode");
            return (Criteria) this;
        }

        public Criteria andInsertByIsNull() {
            addCriterion("INSERT_BY is null");
            return (Criteria) this;
        }

        public Criteria andInsertByIsNotNull() {
            addCriterion("INSERT_BY is not null");
            return (Criteria) this;
        }

        public Criteria andInsertByEqualTo(String value) {
            addCriterion("INSERT_BY =", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByNotEqualTo(String value) {
            addCriterion("INSERT_BY <>", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByGreaterThan(String value) {
            addCriterion("INSERT_BY >", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByGreaterThanOrEqualTo(String value) {
            addCriterion("INSERT_BY >=", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByLessThan(String value) {
            addCriterion("INSERT_BY <", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByLessThanOrEqualTo(String value) {
            addCriterion("INSERT_BY <=", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByLike(String value) {
            addCriterion("INSERT_BY like", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByNotLike(String value) {
            addCriterion("INSERT_BY not like", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByIn(List<String> values) {
            addCriterion("INSERT_BY in", values, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByNotIn(List<String> values) {
            addCriterion("INSERT_BY not in", values, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByBetween(String value1, String value2) {
            addCriterion("INSERT_BY between", value1, value2, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByNotBetween(String value1, String value2) {
            addCriterion("INSERT_BY not between", value1, value2, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertDateIsNull() {
            addCriterion("INSERT_DATE is null");
            return (Criteria) this;
        }

        public Criteria andInsertDateIsNotNull() {
            addCriterion("INSERT_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andInsertDateEqualTo(Date value) {
            addCriterion("INSERT_DATE =", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateNotEqualTo(Date value) {
            addCriterion("INSERT_DATE <>", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateGreaterThan(Date value) {
            addCriterion("INSERT_DATE >", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateGreaterThanOrEqualTo(Date value) {
            addCriterion("INSERT_DATE >=", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateLessThan(Date value) {
            addCriterion("INSERT_DATE <", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateLessThanOrEqualTo(Date value) {
            addCriterion("INSERT_DATE <=", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateIn(List<Date> values) {
            addCriterion("INSERT_DATE in", values, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateNotIn(List<Date> values) {
            addCriterion("INSERT_DATE not in", values, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateBetween(Date value1, Date value2) {
            addCriterion("INSERT_DATE between", value1, value2, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateNotBetween(Date value1, Date value2) {
            addCriterion("INSERT_DATE not between", value1, value2, "insertDate");
            return (Criteria) this;
        }

        public Criteria andProviderServiceFeeDbcdIsNull() {
            addCriterion("PROVIDER_SERVICE_FEE_DBCD is null");
            return (Criteria) this;
        }

        public Criteria andProviderServiceFeeDbcdIsNotNull() {
            addCriterion("PROVIDER_SERVICE_FEE_DBCD is not null");
            return (Criteria) this;
        }

        public Criteria andProviderServiceFeeDbcdEqualTo(String value) {
            addCriterion("PROVIDER_SERVICE_FEE_DBCD =", value, "providerServiceFeeDbcd");
            return (Criteria) this;
        }

        public Criteria andProviderServiceFeeDbcdNotEqualTo(String value) {
            addCriterion("PROVIDER_SERVICE_FEE_DBCD <>", value, "providerServiceFeeDbcd");
            return (Criteria) this;
        }

        public Criteria andProviderServiceFeeDbcdGreaterThan(String value) {
            addCriterion("PROVIDER_SERVICE_FEE_DBCD >", value, "providerServiceFeeDbcd");
            return (Criteria) this;
        }

        public Criteria andProviderServiceFeeDbcdGreaterThanOrEqualTo(String value) {
            addCriterion("PROVIDER_SERVICE_FEE_DBCD >=", value, "providerServiceFeeDbcd");
            return (Criteria) this;
        }

        public Criteria andProviderServiceFeeDbcdLessThan(String value) {
            addCriterion("PROVIDER_SERVICE_FEE_DBCD <", value, "providerServiceFeeDbcd");
            return (Criteria) this;
        }

        public Criteria andProviderServiceFeeDbcdLessThanOrEqualTo(String value) {
            addCriterion("PROVIDER_SERVICE_FEE_DBCD <=", value, "providerServiceFeeDbcd");
            return (Criteria) this;
        }

        public Criteria andProviderServiceFeeDbcdLike(String value) {
            addCriterion("PROVIDER_SERVICE_FEE_DBCD like", value, "providerServiceFeeDbcd");
            return (Criteria) this;
        }

        public Criteria andProviderServiceFeeDbcdNotLike(String value) {
            addCriterion("PROVIDER_SERVICE_FEE_DBCD not like", value, "providerServiceFeeDbcd");
            return (Criteria) this;
        }

        public Criteria andProviderServiceFeeDbcdIn(List<String> values) {
            addCriterion("PROVIDER_SERVICE_FEE_DBCD in", values, "providerServiceFeeDbcd");
            return (Criteria) this;
        }

        public Criteria andProviderServiceFeeDbcdNotIn(List<String> values) {
            addCriterion("PROVIDER_SERVICE_FEE_DBCD not in", values, "providerServiceFeeDbcd");
            return (Criteria) this;
        }

        public Criteria andProviderServiceFeeDbcdBetween(String value1, String value2) {
            addCriterion("PROVIDER_SERVICE_FEE_DBCD between", value1, value2, "providerServiceFeeDbcd");
            return (Criteria) this;
        }

        public Criteria andProviderServiceFeeDbcdNotBetween(String value1, String value2) {
            addCriterion("PROVIDER_SERVICE_FEE_DBCD not between", value1, value2, "providerServiceFeeDbcd");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionIsNull() {
            addCriterion("SELFPAID_COLLECTION is null");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionIsNotNull() {
            addCriterion("SELFPAID_COLLECTION is not null");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionEqualTo(String value) {
            addCriterion("SELFPAID_COLLECTION =", value, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionNotEqualTo(String value) {
            addCriterion("SELFPAID_COLLECTION <>", value, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionGreaterThan(String value) {
            addCriterion("SELFPAID_COLLECTION >", value, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionGreaterThanOrEqualTo(String value) {
            addCriterion("SELFPAID_COLLECTION >=", value, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionLessThan(String value) {
            addCriterion("SELFPAID_COLLECTION <", value, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionLessThanOrEqualTo(String value) {
            addCriterion("SELFPAID_COLLECTION <=", value, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionLike(String value) {
            addCriterion("SELFPAID_COLLECTION like", value, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionNotLike(String value) {
            addCriterion("SELFPAID_COLLECTION not like", value, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionIn(List<String> values) {
            addCriterion("SELFPAID_COLLECTION in", values, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionNotIn(List<String> values) {
            addCriterion("SELFPAID_COLLECTION not in", values, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionBetween(String value1, String value2) {
            addCriterion("SELFPAID_COLLECTION between", value1, value2, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionNotBetween(String value1, String value2) {
            addCriterion("SELFPAID_COLLECTION not between", value1, value2, "selfpaidCollection");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}